home *** CD-ROM | disk | FTP | other *** search
- COUNT2
- Reads the value in searchvalue, searches the remaining arguments for occurrences of that value, and displays the count in the cell or field specified.
-
- Format: COUNT2 (searchvalue, value1,...)
-
- Arguments:
- ΓÇó searchvalue: A number, cell reference, or range.
- ΓÇó value: A number, cell reference, or range.
-
- Example:
- COUNT2 (10, 20, 10, 34, 10) returns 2.
- Shows that the value of the first argument, 10, occurs twice in the arguments that follow.